USE [TBbilling]
GO
/****** Object:  StoredProcedure [dbo].[UpdateTransferDate]    Script Date: 02/06/2015 15:43:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[UpdateTransferDate] @TransferStartdate datetime
as 

begin
 set nocount on

Update TBbilling.dbo.transferAudit
  set TransferEnddate = GETDATE()
  where TransferStartDate = @TransferStartdate

set nocount off
 
end
GO
